Table Options

Identity

Seed
The value used for the very first row loaded into the table.

Increment
The incremental value added to the identity value of the previous row loaded.

Current
Set the current identity value.

Not for Replication
Values are not incremented in identity columns when replication agents perform inserts.

Note: SQL Azure does not support.

Change Tracking

Change Tracking
Specify change tracking is enabled for the table.

Note: Support from SQL Server 2008 or later.

Track Columns Updated
Specify the Database Engine tracks which change tracked columns were updated.

Note: Support from SQL Server 2008 or later.

Lock Escalation
Specify the allowed methods of lock escalation for a table.

Note: Support from SQL Server 2008 or later.